using System;
using System.Collections.Generic;
using System.Text;
using Shc.Sql;
using Shc.Json;
namespace Slqj.Data
{
	public static class TableViewOrderItem
	{
		public const string Table = "View_OrderItem";
		public const string TicketOrderItemsID = "TicketOrderItemsID";
		public const string OrdersID = "OrdersID";
		public const string TicketsID = "TicketsID";
		public const string AttractionsID = "AttractionsID";
		public const string TicketTypeID = "TicketTypeID";
		public const string TicketTypeName = "TicketTypeName";
		public const string TicketsName = "TicketsName";
		public const string OriginalPrice = "OriginalPrice";
		public const string SettlementPrice = "SettlementPrice";
		public const string SalesGuidePrice = "SalesGuidePrice";
		public const string Discount = "Discount";
		public const string BackPoint = "BackPoint";
		public const string Quantity = "Quantity";
		public const string Tax = "Tax";
		public const string TotalAmount = "TotalAmount";
		public const string Creater = "Creater";
		public const string CreatedBy = "CreatedBy";
		public const string Created = "Created";
		public const string Modified = "Modified";
		public const string ModifiedBy = "ModifiedBy";
		public const string ModifiedByID = "ModifiedByID";
		public const string MembersID = "MembersID";
		public const string MemberName = "MemberName";
		public const string Contact = "Contact";
		public const string OrderStatusID = "OrderStatusID";
		public const string OrdersNo = "OrdersNo";
		public const string OrderTypeID = "OrderTypeID";
		public const string OrderDate = "OrderDate";
		public const string Description = "Description";
		public const string OrderTotalAmount = "OrderTotalAmount";
		public const string OrderTypeName = "OrderTypeName";
		public const string OrderStatusName = "OrderStatusName";
		public const string OrderCreated = "OrderCreated";
		public const string AttractionsName = "AttractionsName";
		public const string ContactPhone = "ContactPhone";
		public const string Visitors = "Visitors";
		public const string CustomerName = "CustomerName";
		public const string ItemOrdersNo = "ItemOrdersNo";
		public const string IsVerify = "IsVerify";
		public const string VerifyDate = "VerifyDate";
		public const string VerifierID = "VerifierID";
		public const string VerifyRemarks = "VerifyRemarks";
		public const string VerifierAccount = "VerifierAccount";
		public const string OrderItemDate = "OrderItemDate";
	}
	
	[Serializable]
	public class BaseViewOrderItem
		: IDbSessionEntity, IJsonClass
	{
		int m_TicketOrderItemsID;
		/// <summary>
        /// 
        /// </summary>
        public int TicketOrderItemsID
        {
            get { return m_TicketOrderItemsID; }
            set { m_TicketOrderItemsID = value; }
        }
		
		int? m_OrdersID;
		/// <summary>
        /// 
        /// </summary>
        public int? OrdersID
        {
            get { return m_OrdersID; }
            set { m_OrdersID = value; }
        }
		
		int m_TicketsID;
		/// <summary>
        /// 
        /// </summary>
        public int TicketsID
        {
            get { return m_TicketsID; }
            set { m_TicketsID = value; }
        }
		
		int? m_AttractionsID;
		/// <summary>
        /// 
        /// </summary>
        public int? AttractionsID
        {
            get { return m_AttractionsID; }
            set { m_AttractionsID = value; }
        }
		
		int m_TicketTypeID;
		/// <summary>
        /// 
        /// </summary>
        public int TicketTypeID
        {
            get { return m_TicketTypeID; }
            set { m_TicketTypeID = value; }
        }
		
		string m_TicketTypeName;
		/// <summary>
        /// 
        /// </summary>
        public string TicketTypeName
        {
            get { return m_TicketTypeName; }
            set { m_TicketTypeName = value; }
        }
		
		string m_TicketsName;
		/// <summary>
        /// 
        /// </summary>
        public string TicketsName
        {
            get { return m_TicketsName; }
            set { m_TicketsName = value; }
        }
		
		double m_OriginalPrice;
		/// <summary>
        /// 
        /// </summary>
        public double OriginalPrice
        {
            get { return m_OriginalPrice; }
            set { m_OriginalPrice = value; }
        }
		
		double m_SettlementPrice;
		/// <summary>
        /// 
        /// </summary>
        public double SettlementPrice
        {
            get { return m_SettlementPrice; }
            set { m_SettlementPrice = value; }
        }
		
		double m_SalesGuidePrice;
		/// <summary>
        /// 
        /// </summary>
        public double SalesGuidePrice
        {
            get { return m_SalesGuidePrice; }
            set { m_SalesGuidePrice = value; }
        }
		
		double m_Discount;
		/// <summary>
        /// 
        /// </summary>
        public double Discount
        {
            get { return m_Discount; }
            set { m_Discount = value; }
        }
		
		double m_BackPoint;
		/// <summary>
        /// 
        /// </summary>
        public double BackPoint
        {
            get { return m_BackPoint; }
            set { m_BackPoint = value; }
        }
		
		int m_Quantity;
		/// <summary>
        /// 
        /// </summary>
        public int Quantity
        {
            get { return m_Quantity; }
            set { m_Quantity = value; }
        }
		
		double m_Tax;
		/// <summary>
        /// 
        /// </summary>
        public double Tax
        {
            get { return m_Tax; }
            set { m_Tax = value; }
        }
		
		double m_TotalAmount;
		/// <summary>
        /// 
        /// </summary>
        public double TotalAmount
        {
            get { return m_TotalAmount; }
            set { m_TotalAmount = value; }
        }
		
		int m_Creater;
		/// <summary>
        /// 
        /// </summary>
        public int Creater
        {
            get { return m_Creater; }
            set { m_Creater = value; }
        }
		
		string m_CreatedBy;
		/// <summary>
        /// 
        /// </summary>
        public string CreatedBy
        {
            get { return m_CreatedBy; }
            set { m_CreatedBy = value; }
        }
		
		DateTime m_Created;
		/// <summary>
        /// 
        /// </summary>
        public DateTime Created
        {
            get { return m_Created; }
            set { m_Created = value; }
        }
		
		DateTime m_Modified;
		/// <summary>
        /// 
        /// </summary>
        public DateTime Modified
        {
            get { return m_Modified; }
            set { m_Modified = value; }
        }
		
		string m_ModifiedBy;
		/// <summary>
        /// 
        /// </summary>
        public string ModifiedBy
        {
            get { return m_ModifiedBy; }
            set { m_ModifiedBy = value; }
        }
		
		int? m_ModifiedByID;
		/// <summary>
        /// 
        /// </summary>
        public int? ModifiedByID
        {
            get { return m_ModifiedByID; }
            set { m_ModifiedByID = value; }
        }
		
		int m_MembersID;
		/// <summary>
        /// 
        /// </summary>
        public int MembersID
        {
            get { return m_MembersID; }
            set { m_MembersID = value; }
        }
		
		string m_MemberName;
		/// <summary>
        /// 
        /// </summary>
        public string MemberName
        {
            get { return m_MemberName; }
            set { m_MemberName = value; }
        }
		
		string m_Contact;
		/// <summary>
        /// 
        /// </summary>
        public string Contact
        {
            get { return m_Contact; }
            set { m_Contact = value; }
        }
		
		int? m_OrderStatusID;
		/// <summary>
        /// 
        /// </summary>
        public int? OrderStatusID
        {
            get { return m_OrderStatusID; }
            set { m_OrderStatusID = value; }
        }
		
		string m_OrdersNo;
		/// <summary>
        /// 
        /// </summary>
        public string OrdersNo
        {
            get { return m_OrdersNo; }
            set { m_OrdersNo = value; }
        }
		
		int? m_OrderTypeID;
		/// <summary>
        /// 
        /// </summary>
        public int? OrderTypeID
        {
            get { return m_OrderTypeID; }
            set { m_OrderTypeID = value; }
        }
		
		DateTime m_OrderDate;
		/// <summary>
        /// 
        /// </summary>
        public DateTime OrderDate
        {
            get { return m_OrderDate; }
            set { m_OrderDate = value; }
        }
		
		string m_Description;
		/// <summary>
        /// 
        /// </summary>
        public string Description
        {
            get { return m_Description; }
            set { m_Description = value; }
        }
		
		double m_OrderTotalAmount;
		/// <summary>
        /// 
        /// </summary>
        public double OrderTotalAmount
        {
            get { return m_OrderTotalAmount; }
            set { m_OrderTotalAmount = value; }
        }
		
		string m_OrderTypeName;
		/// <summary>
        /// 
        /// </summary>
        public string OrderTypeName
        {
            get { return m_OrderTypeName; }
            set { m_OrderTypeName = value; }
        }
		
		string m_OrderStatusName;
		/// <summary>
        /// 
        /// </summary>
        public string OrderStatusName
        {
            get { return m_OrderStatusName; }
            set { m_OrderStatusName = value; }
        }
		
		DateTime m_OrderCreated;
		/// <summary>
        /// 
        /// </summary>
        public DateTime OrderCreated
        {
            get { return m_OrderCreated; }
            set { m_OrderCreated = value; }
        }
		
		string m_AttractionsName;
		/// <summary>
        /// 
        /// </summary>
        public string AttractionsName
        {
            get { return m_AttractionsName; }
            set { m_AttractionsName = value; }
        }
		
		string m_ContactPhone;
		/// <summary>
        /// 
        /// </summary>
        public string ContactPhone
        {
            get { return m_ContactPhone; }
            set { m_ContactPhone = value; }
        }
		
		string m_Visitors;
		/// <summary>
        /// 
        /// </summary>
        public string Visitors
        {
            get { return m_Visitors; }
            set { m_Visitors = value; }
        }
		
		string m_CustomerName;
		/// <summary>
        /// 
        /// </summary>
        public string CustomerName
        {
            get { return m_CustomerName; }
            set { m_CustomerName = value; }
        }
		
		string m_ItemOrdersNo;
		/// <summary>
        /// 
        /// </summary>
        public string ItemOrdersNo
        {
            get { return m_ItemOrdersNo; }
            set { m_ItemOrdersNo = value; }
        }
		
		bool m_IsVerify;
		/// <summary>
        /// 
        /// </summary>
        public bool IsVerify
        {
            get { return m_IsVerify; }
            set { m_IsVerify = value; }
        }
		
		DateTime? m_VerifyDate;
		/// <summary>
        /// 
        /// </summary>
        public DateTime? VerifyDate
        {
            get { return m_VerifyDate; }
            set { m_VerifyDate = value; }
        }
		
		int m_VerifierID;
		/// <summary>
        /// 
        /// </summary>
        public int VerifierID
        {
            get { return m_VerifierID; }
            set { m_VerifierID = value; }
        }
		
		string m_VerifyRemarks;
		/// <summary>
        /// 
        /// </summary>
        public string VerifyRemarks
        {
            get { return m_VerifyRemarks; }
            set { m_VerifyRemarks = value; }
        }
		
		string m_VerifierAccount;
		/// <summary>
        /// 
        /// </summary>
        public string VerifierAccount
        {
            get { return m_VerifierAccount; }
            set { m_VerifierAccount = value; }
        }
		
		DateTime m_OrderItemDate;
		/// <summary>
        /// 
        /// </summary>
        public DateTime OrderItemDate
        {
            get { return m_OrderItemDate; }
            set { m_OrderItemDate = value; }
        }
		
		
		#region IDbSessionEntity Members
		public void ReadDBData(RowDataReader reader)
        {
            m_TicketOrderItemsID = reader[TableViewOrderItem.TicketOrderItemsID];
            m_OrdersID = reader[TableViewOrderItem.OrdersID];
            m_TicketsID = reader[TableViewOrderItem.TicketsID];
            m_AttractionsID = reader[TableViewOrderItem.AttractionsID];
            m_TicketTypeID = reader[TableViewOrderItem.TicketTypeID];
            m_TicketTypeName = reader[TableViewOrderItem.TicketTypeName];
            m_TicketsName = reader[TableViewOrderItem.TicketsName];
            m_OriginalPrice = reader[TableViewOrderItem.OriginalPrice];
            m_SettlementPrice = reader[TableViewOrderItem.SettlementPrice];
            m_SalesGuidePrice = reader[TableViewOrderItem.SalesGuidePrice];
            m_Discount = reader[TableViewOrderItem.Discount];
            m_BackPoint = reader[TableViewOrderItem.BackPoint];
            m_Quantity = reader[TableViewOrderItem.Quantity];
            m_Tax = reader[TableViewOrderItem.Tax];
            m_TotalAmount = reader[TableViewOrderItem.TotalAmount];
            m_Creater = reader[TableViewOrderItem.Creater];
            m_CreatedBy = reader[TableViewOrderItem.CreatedBy];
            m_Created = reader[TableViewOrderItem.Created];
            m_Modified = reader[TableViewOrderItem.Modified];
            m_ModifiedBy = reader[TableViewOrderItem.ModifiedBy];
            m_ModifiedByID = reader[TableViewOrderItem.ModifiedByID];
            m_MembersID = reader[TableViewOrderItem.MembersID];
            m_MemberName = reader[TableViewOrderItem.MemberName];
            m_Contact = reader[TableViewOrderItem.Contact];
            m_OrderStatusID = reader[TableViewOrderItem.OrderStatusID];
            m_OrdersNo = reader[TableViewOrderItem.OrdersNo];
            m_OrderTypeID = reader[TableViewOrderItem.OrderTypeID];
            m_OrderDate = reader[TableViewOrderItem.OrderDate];
            m_Description = reader[TableViewOrderItem.Description];
            m_OrderTotalAmount = reader[TableViewOrderItem.OrderTotalAmount];
            m_OrderTypeName = reader[TableViewOrderItem.OrderTypeName];
            m_OrderStatusName = reader[TableViewOrderItem.OrderStatusName];
            m_OrderCreated = reader[TableViewOrderItem.OrderCreated];
            m_AttractionsName = reader[TableViewOrderItem.AttractionsName];
            m_ContactPhone = reader[TableViewOrderItem.ContactPhone];
            m_Visitors = reader[TableViewOrderItem.Visitors];
            m_CustomerName = reader[TableViewOrderItem.CustomerName];
            m_ItemOrdersNo = reader[TableViewOrderItem.ItemOrdersNo];
            m_IsVerify = reader[TableViewOrderItem.IsVerify];
            m_VerifyDate = reader[TableViewOrderItem.VerifyDate];
            m_VerifierID = reader[TableViewOrderItem.VerifierID];
            m_VerifyRemarks = reader[TableViewOrderItem.VerifyRemarks];
            m_VerifierAccount = reader[TableViewOrderItem.VerifierAccount];
            m_OrderItemDate = reader[TableViewOrderItem.OrderItemDate];
        }
		
		public void WriteDBData(RowDataWriter writer)
        {
        }

        public void SetIdentityAfterInsert(DBObject idd)
        {
        }
		
		public string TableName
        {
            get { return TableViewOrderItem.Table; }
        }
		#endregion
		
		
		#region IJsonClass Members

        public void JsonDeSerializeObj(JsonHashTable hashToRead)
        {
             m_TicketOrderItemsID = hashToRead["TicketOrderItemsID"];
			 
             m_OrdersID = hashToRead["OrdersID"];
			 
             m_TicketsID = hashToRead["TicketsID"];
			 
             m_AttractionsID = hashToRead["AttractionsID"];
			 
             m_TicketTypeID = hashToRead["TicketTypeID"];
			 
             m_TicketTypeName = hashToRead["TicketTypeName"];
			 
             m_TicketsName = hashToRead["TicketsName"];
			 
             m_OriginalPrice = hashToRead["OriginalPrice"];
			 
             m_SettlementPrice = hashToRead["SettlementPrice"];
			 
             m_SalesGuidePrice = hashToRead["SalesGuidePrice"];
			 
             m_Discount = hashToRead["Discount"];
			 
             m_BackPoint = hashToRead["BackPoint"];
			 
             m_Quantity = hashToRead["Quantity"];
			 
             m_Tax = hashToRead["Tax"];
			 
             m_TotalAmount = hashToRead["TotalAmount"];
			 
             m_Creater = hashToRead["Creater"];
			 
             m_CreatedBy = hashToRead["CreatedBy"];
			 
             m_Created = hashToRead["Created"];
			 
             m_Modified = hashToRead["Modified"];
			 
             m_ModifiedBy = hashToRead["ModifiedBy"];
			 
             m_ModifiedByID = hashToRead["ModifiedByID"];
			 
             m_MembersID = hashToRead["MembersID"];
			 
             m_MemberName = hashToRead["MemberName"];
			 
             m_Contact = hashToRead["Contact"];
			 
             m_OrderStatusID = hashToRead["OrderStatusID"];
			 
             m_OrdersNo = hashToRead["OrdersNo"];
			 
             m_OrderTypeID = hashToRead["OrderTypeID"];
			 
             m_OrderDate = hashToRead["OrderDate"];
			 
             m_Description = hashToRead["Description"];
			 
             m_OrderTotalAmount = hashToRead["OrderTotalAmount"];
			 
             m_OrderTypeName = hashToRead["OrderTypeName"];
			 
             m_OrderStatusName = hashToRead["OrderStatusName"];
			 
             m_OrderCreated = hashToRead["OrderCreated"];
			 
             m_AttractionsName = hashToRead["AttractionsName"];
			 
             m_ContactPhone = hashToRead["ContactPhone"];
			 
             m_Visitors = hashToRead["Visitors"];
			 
             m_CustomerName = hashToRead["CustomerName"];
			 
             m_ItemOrdersNo = hashToRead["ItemOrdersNo"];
			 
             m_IsVerify = hashToRead["IsVerify"];
			 
             m_VerifyDate = hashToRead["VerifyDate"];
			 
             m_VerifierID = hashToRead["VerifierID"];
			 
             m_VerifyRemarks = hashToRead["VerifyRemarks"];
			 
             m_VerifierAccount = hashToRead["VerifierAccount"];
			 
             m_OrderItemDate = hashToRead["OrderItemDate"];
			 
        }

        public void JsonSerializeObj(JsonHashTable hashToFill)
        {
            hashToFill["TicketOrderItemsID"] = TicketOrderItemsID;
			
            hashToFill["OrdersID"] = OrdersID;
			
            hashToFill["TicketsID"] = TicketsID;
			
            hashToFill["AttractionsID"] = AttractionsID;
			
            hashToFill["TicketTypeID"] = TicketTypeID;
			
            hashToFill["TicketTypeName"] = TicketTypeName;
			
            hashToFill["TicketsName"] = TicketsName;
			
            hashToFill["OriginalPrice"] = OriginalPrice;
			
            hashToFill["SettlementPrice"] = SettlementPrice;
			
            hashToFill["SalesGuidePrice"] = SalesGuidePrice;
			
            hashToFill["Discount"] = Discount;
			
            hashToFill["BackPoint"] = BackPoint;
			
            hashToFill["Quantity"] = Quantity;
			
            hashToFill["Tax"] = Tax;
			
            hashToFill["TotalAmount"] = TotalAmount;
			
            hashToFill["Creater"] = Creater;
			
            hashToFill["CreatedBy"] = CreatedBy;
			
            hashToFill["Created"] = Created;
			
            hashToFill["Modified"] = Modified;
			
            hashToFill["ModifiedBy"] = ModifiedBy;
			
            hashToFill["ModifiedByID"] = ModifiedByID;
			
            hashToFill["MembersID"] = MembersID;
			
            hashToFill["MemberName"] = MemberName;
			
            hashToFill["Contact"] = Contact;
			
            hashToFill["OrderStatusID"] = OrderStatusID;
			
            hashToFill["OrdersNo"] = OrdersNo;
			
            hashToFill["OrderTypeID"] = OrderTypeID;
			
            hashToFill["OrderDate"] = OrderDate;
			
            hashToFill["Description"] = Description;
			
            hashToFill["OrderTotalAmount"] = OrderTotalAmount;
			
            hashToFill["OrderTypeName"] = OrderTypeName;
			
            hashToFill["OrderStatusName"] = OrderStatusName;
			
            hashToFill["OrderCreated"] = OrderCreated;
			
            hashToFill["AttractionsName"] = AttractionsName;
			
            hashToFill["ContactPhone"] = ContactPhone;
			
            hashToFill["Visitors"] = Visitors;
			
            hashToFill["CustomerName"] = CustomerName;
			
            hashToFill["ItemOrdersNo"] = ItemOrdersNo;
			
            hashToFill["IsVerify"] = IsVerify;
			
            hashToFill["VerifyDate"] = VerifyDate;
			
            hashToFill["VerifierID"] = VerifierID;
			
            hashToFill["VerifyRemarks"] = VerifyRemarks;
			
            hashToFill["VerifierAccount"] = VerifierAccount;
			
            hashToFill["OrderItemDate"] = OrderItemDate;
			
        }

        #endregion
		
	}
}
